package com.iris.live.services.data.repositories;

import com.iris.live.services.data.models.销售项目设置Model;
import com.iris.live.services.data.models.销售项目设置ModelPK;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface 销售项目设置Repository extends JpaRepository<销售项目设置Model, 销售项目设置ModelPK>, JpaSpecificationExecutor<销售项目设置Model> {

    @Query("select a from 销售项目设置Model a where a.许可 =?1 and a.设置项目 =?2")
    public 销售项目设置Model cusFirstInAndLeaveDay(String permit,String install);

    @Query("select a from 销售项目设置Model a where a.设置项目 = ?1")
    List<销售项目设置Model> findAllModelByParam (String install);

}
